a541d5f9f18afb5530b275e36b2e8fc161f219a3,tests/frontend/org/voltdb/planner/TestIndexSelection.java,TestIndexSelection,testSkipNullPartialIndex,#,484

Before Change


            // skipNull is required - index predicate is not NULL-rejecting for column B
            AbstractPlanNode pn = compile("select count(*) from c where b > 0 and d > 0;");
            checkIndexName(pn, PlanNodeType.INDEXCOUNT, "\"TARGET_INDEX_NAME\":\"PARTIAL_IDX_3\"");
            checkIndexSkipNullPredicateIsNull(pn, false);
        }
        {
            // CREATE INDEX partial_idx_3 ON c (b) where d > 0;

After Change


            // skipNull predicate is redundant and eliminated
            AbstractPlanNode pn = compile("select count(*) from c where g < 0;");
            checkIndexName(pn, PlanNodeType.INDEXCOUNT, "\"TARGET_INDEX_NAME\":\"PARTIAL_IDX_6\"");
            checkIndexSkipNullPredicateIsNull(pn, false);
        }
        {
            //CREATE INDEX partial_idx_6 ON c (g) where g < 0;